package cn.itcast.bassm.mapper;



import java.sql.Timestamp;
import java.util.List;

import org.apache.ibatis.annotations.Param;

import cn.itcast.bassm.pojo.Push;
import cn.itcast.bassm.pojo.Returnxx;
import cn.itcast.bassm.pojo.Shooting;
import cn.itcast.bassm.pojo.Unitdoor;
import cn.itcast.bassm.pojo.Uploadfile;
import cn.itcast.bassm.pojo.UserInformation;
import cn.itcast.bassm.pojo.Visitors;

public interface PushMapper {
	
	public void savePush(@Param("scenePath")String scenePath1,@Param("Timestamptime")Timestamp Timestamptime);
	
	public List<UserInformation> finPushUser();
	
	public void savexdurl(@Param("scenePath")String scenePath);
	
	public List<Push> showFinUserImg();
	
	public List<Visitors> selectProductsByPage(@Param("startPos")int startPos,@Param("yaddress")String Celladdress1,@Param("pageSize")int pageSize);
	
	public long getProductsCount(@Param("yaddress")String Celladdress1);
	
	public Visitors addqueryUserById(@Param("yid")String yid);
	
	public void updateUserState(@Param("yid")int yid,@Param("yindate")String yindate,@Param("state")String state,@Param("yupdatetime")String yupdatetime,@Param("visitorstype")String visitorstype,@Param("gun")String gun);
	
	public List<Visitors> selectnameonefinPage(@Param("startPos")int startPos,@Param("yname")String yname,@Param("yaddress")String yaddress,@Param("pageSize")int pageSize);
	
	public List<Visitors> selectFinPhoneorUserNameu(@Param("startPos")int startPos,@Param("yphone")String yphone,@Param("yaddress")String yaddress,@Param("pageSize")int pageSize);
	
	public List<Visitors> selectallFInPage(@Param("startPos")int startPos,@Param("yphone")String yphone,@Param("yname")String yname,@Param("yaddress")String yaddress,@Param("pageSize")int pageSize);
	
	
	public long getProductsCount2(@Param("yname")String yname,@Param("yaddress")String yaddress);
	
	public long getProductsCount3(@Param("yphone")String yphone,@Param("yaddress")String yaddress);
	
	public long getProductsCount4(@Param("yphone")String yphone,@Param("yname")String yname,@Param("yaddress")String yaddress);
	
	public void updateUserStatenull(@Param("yid")int yid,@Param("yindate")String yindate,@Param("state")String state,@Param("yupdatetime")String yupdatetime,@Param("visitorstype")String visitorstype,@Param("gun")String gun);

	public List<Unitdoor> selecUnitdoor(@Param("address")String address);
	
	public List<Visitors> selecfinuserlou(@Param("yid")String yid);
	
	public void UpselectFinto(@Param("yname")String yname,@Param("yunitdoor")String yunitdoor,@Param("yid")int yid,@Param("updatetime")String updatetime);

	public List<Shooting> selcetShooting(@Param("address")String address);
	
	public Shooting selcetShootingname(@Param("address")String address);
	
	public long getProductsCountbaihei(@Param("yaddress")String Celladdress1,@Param("yindate")String yindate);
	
	public List<Visitors> selectProductsByPagebaihei(@Param("startPos")int startPos,@Param("yaddress")String Celladdress1,@Param("yindate")String yindate,@Param("pageSize")int pageSize);
	
	public void upfkoneuserend(@Param("yindate")String yindate,@Param("yupdatetime")String yupdatetime,@Param("state")String state,@Param("yid")String yid,@Param("visitorstype")String visitorstype);
	
	public Visitors selecfinuserloupojo(@Param("yid")String yid);
	
	public void UpselectFintotimevisitors(@Param("yindate")String yindate,@Param("state")String state);
	
	public void delecevisitorsone(@Param("yid")String yid,@Param("yupdatetime")String yupdatetime,@Param("state")String state,@Param("visitorstype")String visitorstype,@Param("yindate")String yindate);
}

